<--- KEYCOIN ---> COIN INVENTORY PROGRAM KEYWARE SYSTEMS all rights reserved 様様様様様様様様様様様様様様様様様様様様様様様様様様様様様様様様様様様 This program was written and compiled using Microsoft Quick Basic 4.5 and Microsoft Basic Professional Development System 7.1 This is a shareware program. The concept of shareware is to provide inexpensive software to the public while allowing the author to receive compensation for the many hundreds of hours that are spent on the development of the programs. All users are expected to register, and send in the registration fee. The program and may be distributed freely with a maximum charge of $5.00 per disk. This program may not be offered as part of or in conjunction with any other program or software package without the expressed written consent of the author. Use of this program for profit, or use in any commercial establishment , or use as part of a membership plan by anyone not registered as a commercial user is prohibited. Anyone who uses this program is expected to register as a user in one of the classifications listed below. A registration form is provided on the following page. CLASS FEE A1 $15.00 You will receive the current version of the program, and you will be notified of any changes to the program which are necessary to correct program errors or defects. A distribution fee will be charged for the replacement disks. A2 $30.00 You will receive notifications mentioned above and will be given the opportunity to upgrade the program as new versions and new utilities become available. There will be a minimal charge for the upgrade based on the number of required replacement disks. A copy of the basic source code can be purchased for a small disk distribution charge. (Microsoft Professional Development System (7.0 or later) is required to run or compile the source code. C1-C9 INQUIRE For commercial or club use of this program, write to the address listed on the registration form provided on the following page. REGISTRATION FORM KEYCOIN COIN INVENTORY Version 1.1 PLEASE PRINT OR TYPE ALL REGISTRATION INFORMATION NAME ........................... .......................... (last) (first) STREET ................................ APT ....... ................................................ CITY ......................... STATE ............ ZIP ............ ______________________________________________________________________ AMOUNT ENCLOSED $........... make all checks payable to KEYWARE ______________________________________________________________________ COMMENTS _____________________________________________________________ ______________________________________________________________________ ______________________________________________________________________ ______________________________________________________________________ ______________________________________________________________________ ______________________________________________________________________ ______________________________________________________________________ ______________________________________________________________________ ______________________________________________________________________ Should you be the first to suggest an improvement that is added to this program, you will receive one free upgrade of this program . This offer is limited to one suggestion per program. SEND ALL CORRESPONDENCE TO: KEYWARE 328 ELFORT DR PITTSBURGH, PA. 15235 GENERAL INFORMATION This program has been tailored to perform all necessary functions while retaining the ability to use a 360K diskette for the program and manual, and another 360K diskette for all associated files. Floppy users may encounter a problem if new files are added, since DOS places a limit on the number of files that can be placed on one diskette. The only way to overcome this is to archive some of the files that you do not use, or to merge two or more files. Hard disk users will not encounter this problem. Do not delete any files until you have made a back-up copy of the distribution disk. The distribution disk contains 91 separate coin files and the Master Coin File. The Program and Manual Disk contains the program KEYCOIN.EXE, and two .TXT files. README.TXT contains the basic instructions necessary to print the manual, or begin using the program. KEYCOIN.TXT contains this manual. This program employs a system that allows you to exit any program operation whenever you change your mind, or are not sure of the operation that is in-process. Simply enter a single question mark as the first and only characyer in any field, and you will be returned to the Main Menu. This routine works on all screens and on all input fields throughout the program. The only exception to this is when the gray background selection windows are being displayed. To exit from these windows, select the CANCEL function either with the mouse or tab keys. The program will allow question marks to be used in data fields, as long as there are other characters in the field. The safety system looks for a single question mark, so any of the following would be valid field entries. ??, double die?, planchet defect ?, 1922P? COIN FILE FILENAMES The coin files are named to reflect the denomination, variety and the sequence in which the files were created. The first 6 characters of the filename (7 for half cent) indicate the denomination in cents with leading zeroes. 000001 = 1 cent, 000100 = 1 dollar (100 cents)etc... A denomination value of 99 (000099) has been used for mint sets, proof sets, and a type coin set. The seventh and eighth character (8th only for half cents) are assigned sequentially A1 - A9, B1 - B9 etc. (note that only letters are used for half cents A - Z). As you create new files, the program will assign new names to the file based on this naming system. You need only to define the characteristics of the coins that will be listed in the file. INSTALLING AND RUNNING KEYCOIN.EXE FLOPPY DISK INSTALLATION (for hard disk systems, skip this section) Before using the program, you should make a working disk, and safely store the original distribution disk. Assuming that you have a two drive system, follow the steps listed below to produce a working disk, and a manual disk. In the section below, when you are asked to enter a command, type everything that is shown, and press enter. 1. place your DOS system disk in drive A, and turn on your system 2. with the DOS disk still in drive A, place a blank disk in drive B and format it using the following command FORMAT B: 3. when this is complete, remove the DOS system disk from drive A and replace it with the Files distribution disk 4. copy all files from drive A onto the disk in drive B using the following command COPY A:*.* B: 5. remove the disk from drive B. This is your files working disk. Label this disk KEYCOIN FILES WORKING DISK 6. place another blank disk in drive B, and format it using the following command FORMAT B: 7. when format is complete, place the Program and Manual distribution disk in drive A and copy the Program and manual files from drive A to drive B using the following command COPY A:*.* B: 8. remove the disk from drive B. This is the Program and manual disk. Label this disk KEYCOIN PROGRAM AND MANUAL. 9. remove the distribution disk from drive A. Store both distribution disks in a safe place. 10. When using the program, place the PROGRAM AND MANUAL DISK in drive A. Execute the program by entering the following command KEYCOIN 11. Remove the PROGRAM AND MANUAL DISK from drive A, and replace it with the FILES DISK. Leave the FILES DISK in drive A until you have finished using the program. Skip the next section on HARD DISK INSTALLATION and move to the section titled PROGRAM OPERATION. HARD DISK INSTALLATION In the section below, when you are asked to enter a command, type everything that is shown in capital letters and press enter. 1. log on to the hard disk by entering the following command C: (for drive c) D: (for drive d) 2. Create a directory on your hard disk by entering the following command MKDIR KEYCOIN 3. make the KEYCOIN directory the working directory by entering the following command CD KEYCOIN 4. place the Files distribution disk in drive A. Copy all files to the new directory on the hard disk by entering the following command COPY A:*.* C: (for drive c) COPY A:*.* D: (for drive d) 5. Place the Program and Manual distribution disk in drive A, and enter the following command COPY A:*.* C: (for drive C) COPY A:*.* D: (for drive D) 6. remove the distribution disk from drive A. Store both distribution disks in a safe place. 7. if you do not wish to have the manual stored on your hard disk, enter the following command DEL KEYCOIN.TXT DEL README.TXT 9. to exectue the program, make the KEYCOIN directory the working directory and enter the command KEYCOIN PROGRAM OPERATION To start the program, type KEYCOIN and press enter.The program will execute, and the main menu will be displayed. Main Menu Selections All selections available from the main menu are described in brief detail below. A more detailed description of each function can be found in the sample session section of this manual. Many of the selections use common screens to obtain input about the specific file to be used for the selected function. The first common screen asks for the denomination of the desired file. Enter the denomination value in cents. 1 = cent, 25 = quarter, 100 = dollar, 1000 = Ten dollar, etc... (99= mint sets, proof sets and type sets). A valid entry on this screen will produce a numbered list of all files with the selected denomination. Enter the item number of the desired file. The second common screen, asks whether or not you want the selected file listed to the screen or printer. Press enter to list the file to the screen, or select the printer by using the tab keys or a mouse. Print Coin Files (P) This selection will list all records in the selected file to the line printer or screen. After selecting the file to be printed, you will be given the choice of having the file listed to the line printer or listed on the screen only. Press enter to list the file to the screen, or use the tab keys or a mouse to select the line printer. If the screen option is selected, you will enter the EDIT mode described below. Edit Coin Files (E) This selection will display all records in one selected file, allowing for forward and reverse paging, and will allow you to edit any of the data being displayed. Follow the instructions that appear at the bottom of the screen. Press ENTER to move to the next page, press X to move back one page, press C to activate the change mode, or press A to add new records. In the change mode, move to the desired record using the up and down arrow keys. When the arrows are pointing to the record you want to change, press enter. The data for the selected record will appear in bright letters at the bottom of the screen. You may also add coins to the file from this screen. Press A to activate the Add function. After all desired entries are added, exiting the Add function will return you where you were in the Edit program. See the Field Definition and Restrictions section of this manual for more information on the Edit and Add functions. Report Collection Value (V) Selecting this function will display a smaller menu with choices for reporting the value of the entire collection, one specific set, or all sets of one denomination. Select W, S, or D as appropriate. For selections W and D, only those files with a value greater than zero will be listed. List Missing Coins (L) This selection will list all missing coins in any one set. When asked "LIST COINS BELOW GRADE ", enter a 2-character numeric value between 01 and 71. Coins of the grade entered will not be listed. Only those coins below the specified grade will appear. Enter 01 to list only the missing coins. Enter 71 to list the entire file. Archive / Recall One File (A) This selection may be used to clear coin files from the working disk. You may select the coin files which you do not need, and Archive them until some future time when you expand your collection to include those files. You may also wish to use this selection if you Merge two or more files into a single file. You may then Archive the individual files that were merged to create the combined file. All files that are Archived may be Recalled for future use at any time. You must have two disk drives to use this selection. Checklist (C) This selection will list a coin file in the familiar checklist format. The program will list each date/variety combination only once, and will print a total of all coins within each grade. To ensure that each date/variety is listed only once, the file to be listed should be sorted before running this option. If no changes or additions have been made to the file since the last sort, it will not be necessary to re-sort the file. Print File List (F) This selection will list the master file data for all coin files either to the screen or to the printer. Sort One File (S) This selection should be used whenever new coins have been added to a file, or when changes have been made to existing file records. The file may be sorted by date and variety, variety and date, or by a special type-set sort. Master File Sort (M) This selection should be used when changes have been made to existing file descriptions, or when new files are created. The file will be sorted by denomination value, and first year of issue. Edit File Description (D) This selection will allow you to change the master file description of each individual coin file. Three of the fields in this file are critical to program operation, and generally should not be changed, however there may be occasions where changes to these fields could be beneficial. Before attempting any changes, be sure that you have read and understand the Field Definition and Restrictions as well as the Edit File Description section of this manual. Delete One File (O) This selection will allow you to delete a coin file from the Master File Description. The original file will be deleted from the disk and removed from the COINMSTR File. If you wish to maintain a copy of the file that is being deleted, you must copy the file before using this selection. After the file has been deleted, the Master File will be re-sorted. Always keep a back-up of the original file and the COINMSTR file. While files deleted with this selection can generally be un-deleted using a utilities program such as PC Tools, the COINMSTR file will not recognize the un-deleted file. If you have any reason to suspect that you may need this file in the future, you should use the Archive/Recall function rather than Delete. Do not delete any coin files using DOS commands, or any DOS utility. The file will delete with no problem, however, there will still be a record in the COINMSTR file describing the deleted file. This will not cause any major program problems, but could cause you some confusion when trying to access the file. Always delete coin files using the Delete One File menu selection. Create a New File (N) This selection will allow you to create a new coin file or to split an existing file into two or more smaller files.. You may optionally copy all records from an existing file, or just part of an existing file. You may also include or exclude data for Quantity, Grade, Cost and value. File Merge (T) This selection will merge two files into a single file. The two original files will remain unchanged. The original files may be deleted, Archived and then Recalled for future use, or they can remain active provided you have enough disk space. The merge selection can be used by floppy drive users to reduce the number of files on a disk. Experience has shown that small files are easier to manage and maintain than large merged files. You may want to keep this in mind should you decide to merge two or more files. Archive/Recall One File (A) You must have a two drive system to use this function. Files can be archived to either drive A or B. If you have a system with two floppy drives and are using drive A to run the program, you should archive your files to drive B. If you are using drive B to run the program, archive your files to drive A. Hard disk users may archive files to either drive A or B. If both of your floppy drives are the same size/type, files archived to one drive (A or B) may be recalled from either drive. The files will be archived with the same filename used in the COINMSTR file and will have a filename extension of KEY. There will also be a COINMSTR.KEY file on the archive disk. Since new files may be added after some other files have been archived, the program will automatically re-name any file which already exists on the target drive. Quit Session (Q) This selection should always be used when you are ready to exit the program, to assure that all files are properly closed and that all new data has been written to disk. Some of the selections on the Main Menu change the File Descriptions. The Master File, and all individual coin files must be backed-up together whenever files are deleted, added, changed, merged, archived, or re-sorted. An old back-up of the Master File will not work properly with updated (newer) versions of individual coin files. Whenever making a back-up copy of a coin file, always back-up the COINMSTR file as well. FIELD DEFINITIONS AND RESTRICTIONS COIN MASTER FILE (COINMSTR) This file contains all of the information that the programs need to operate. In a sense, it is an index to all coin files that were either supplied with the program or created using the program. The information in this file is used by all program menu selections. The data contained in this file and the field names are listed below. FIELD NAME LENGTH DESCRIPTION Number of records 5 This entry must be numbers only in range of 1 to 99999. This field is used by the programs to determine the number of records in each coin file. This field is controlled and maintained by the program. Denomination 20 This entry can be any combination of letters and numbers such as CENT HALF DOLLAR DOUBLE EAGLE etc... VARIETY 30 This entry can be any combination of letters and numbers to describe the variety, such as LINCOLN / WALKING LIBERTY / etc... VALUE 6 The value in cents for the listed denomination. Must be numbers only 1 - 999999. YEAR 4 Year of issue for the variety. Must be all numbers, and must be exactly 4 characters. 0560 / 1892 / 1909 / 1938 / etc... FILENAME 8 The name of the file to be used for the denomination/variety. This must be a valid DOS filename, and for this program, it must be exactly 8 characters. This field is controlled and maintained by the program. 000001A1 000100B2 005000A8 etc. INDIVIDUAL COIN FILES These files store the data for each coin in the denomination/variety described in the Coin Master File. The fields used in this file are listed below. FIELD LENGTH DESCRIPTION DATE 8 Date and mint of each individual coin. 1909 1909S 1881CC etc... VARIETY 20 Any additional information needed to describe the coin. VDB , PROOF, 7 OVER 8, DOUBLE DIE, D/S, etc... GRADE 2 The grade of the coin. This entry must be exactly 2 characters, and for proper program operation must be numbers only. 02, 08, 30, 40, 55, 60, 65 etc... QUANTITY 6 The number of coins of the date & grade. (1 to 999999) COST 6 The price you paid for each coin. Must be numbers only .01 to 999999. .01, 3.45, 1250.37 etc... VALUE 6 The current market value of each coin. Must be numbers only .01 to 999999. .01, 3.45, 123456 etc.... SAMPLE SESSIONS We will now run through all of the menu selections, and perform all of the various functions available. When you are through with this session you will have added, deleted, changed and sorted individual and master coin records, and should be well on your way to using the program for your own coin collection inventory. Make a copy of your working disks to use for these sample sessions. Be sure that you are not using the distribution disks for this practice session. PRINT COIN FILES (P) This selection will allow you to print a file to the printer, or display the file on screen. From the main menu select P. For this demo, we will print the Eisenhower Dollar coin file both to the printer, and to the screen. When asked for the denomination type 100 and press enter. (remember that the denomination is in cents. $1 = 100). A list of all coin files with a denomination of 100 will appear. Select the file number for the Eisenhower series and press enter. The screen will clear, and a selection box will be displayed. Use the tab keys or mouse to select the printer and press enter. The listing of all coins in the Eisenhower dollar series will be listed to the printer, and you will be returned to the main menu. To list the file to the screen, repeat all of the above steps until the selection box is displayed. At this point simply press enter. The first 15 coins in the series will be displayed on the screen. To view the next 15 coins, press enter to move to the next page. Note the numbers in the upper right and left corners of the screen. The upper right number is the total number of coins in the file being displayed. The number in the upper left is the record number of the first coin displayed on the current screen. This screen shows that the 1976 variety II is the 16th coin in a series of 27 coins. Press X to return to page one, and see that the number in the upper left changes. You may move backward and forward through the file, or type a ? to return to the main menu. The other functions on this screen are covered in the next section. For now just display the file, paging forward and backward as you desire. EDIT COIN FILES (E) For this demo, we will add a grade, quantity, cost and value to one record in the Franklin Half Dollar series. From the main menu, select E. When asked for the denomination type 50 and press enter. A list of all coin files with a denomination of 50 will be displayed. Select the file number for the Franklin series and press enter. The first screen will list all dates and mints from 1948 to 1953D. The coin that we want to change is 1958, so press enter to move to the next screen. The coin that we want to change is on this screen, so press C to enter the the change mode. There will be arrows pointing to the 1953S record. Use the up arrow or down arrow keys to move to 1958. When the arrows are pointing to 1958, press enter. All of the current data for the 1958 date will be displayed in bright letters at the bottom of the screen, and the cursor will be under the DATE field. We do not wish to change the date, so just press enter and the cursor will move to the next field. There is nothing to enter in the variety field, so again press enter. Now the cursor is in the field where the grade is to be entered. This entry must be 2 characters, and must be numeric. (06, 12, 55 etc.) Let's use 65. Type 65 and press enter. The cursor will now move to the quantity column. Enter the number of these coins that you have in grade 65 (use 5) and press enter. The cursor is now in the cost column. Enter the amount that you paid for each coin (not the total). Since you found these in an original roll that you got at a flea market for the silver spot price, type 3.50 and press enter. The cursor now moves to the value column. Enter the fair market value for 1958 MS65 Franklin Half Dollars. Type 75.00 and press enter. The bottom section of the screen will clear, and you may now either page forward, page backward, return to the main menu, or make another change. Let's change the number of coins in the previous entry from 5 to 6. Press C to enter the change mode, move the arrows to 1958 and press enter. We do not wish to change the date, variety or grade, so press enter when the cursor is under these fields. When the cursor is under the quantity field, type 6 and press enter. Since no changes are to be made to any of the remaining fields, press enter 3 times to return to the paging mode. This program section is also used to tag a record that you wish to delete from the file. When in the paging mode, press C to enter the change mode. Move the arrows to the record that you wish to delete and press enter. When the program is asking for the date, type a single space and press enter. You do not have to make any changes to the remaining fields, so just press enter for the variety, grade, quantity, cost and value fields. The record will be removed from the file the next time the file is sorted. To demonstrate how the ? function works on this screen, let's make a change to the above record one more time. Press C to enter the change mode, move the arrows to 1958, and press enter. For the date type 1988, for the variety type in a message (something like RARE DATE). In the grade column, type a ? and press enter. The program will return you to the paging mode. Note that none of the fields that we entered have been changed. Type a ? and press enter. You are now back at the main menu. It is important to note here that the cost and value columns are for each single coin. If you have 5 coins of the same date and grade, and you paid $10.00 for each coin, ($50.00 for all 5) enter 10 in the cost column. When the program computes the value of a file, the quantity is multiplied by the cost, and by the value to determine the total cost and total value. Before moving on to the next section, add some coin data to other files, and make changes until you are comfortable with the operation of the program. The reports and displays in the following sections will be much more meaningful and can only fully demonstrate program operation when a variety of data has been entered into a number of different files. The more data you enter here, the better you will be able to observe all of the program functions in the following sections. There is one more function available in the EDIT COIN FILES section of the program. While in the paging mode, type A. This will take you into the ADD TO EXISTING FILE program. You may try this function now or wait until we get to the ADD section a little later. REPORT COLLECTION VALUE (R) From the main menu, select R. The screen will clear, and you will be presented with 3 choices, one Denomination, one Set, and Whole collection. For the first demo, select S for one set. Answer the questions for denomination and series using a series that has had data entered in the above operation. The program will read the specified coin file, and display the total cost, and total value of all coins in the file. Press enter to return to the main menu, and again select R. For the second demo, select D for one denomination and answer the following question for the denomination using a denomination for which more than one file has had data entered. The program will read all coin files with the selected denomination, and will report the total cost and value only for the files which have at least one coin with a quantity greater than zero. The files in the selected denomination that have no coin data will not be listed on this report. Press enter to return to the main menu, and again select R. For the final demo in this section, select W for the whole collection. The program will now read all coin files and report all files which have a value greater than zero. Any file which has no coin data will not be listed on this report. Run through all of the reports as many times as necessary, and go back to the edit function if you want to see the affect that changes to a coin file will have on the reports generated by this function. LIST MISSING COINS (L) This selection will list all coins below a specified grade. If you are trying to build a set of coins that all grade VF-20 or higher, this selection will list all coins that either have no quantity, or have a grade lower than 20. This means that any coins you already have will be listed if they grade lower than 20. Select L from the main menu, and when asked for the grade, type 20 and press enter. Use 01 for the grade if you want to list only those coins that are missing. Use 71 to list the entire file. You may list the coins either to the screen or to the printer. ADD TO EXISTING FILE (use Edit One File) This selection will allow you to add coins at the end of an existing file. Use this selection as new dates are issued, or when you want to add a coin that is not included in the file. The data entered must meet the requirements listed in the Field Definitions section of this manual. You can enter this section from the EDIT COIN FILES section of the program by selecting A while in the paging mode. When you have finished adding new coins, you will return to the same place in the EDIT session that you were in before entering the ADD mode. You may want to try adding a few coins to a file, and then use the delete procedure listed under the EDIT section. Coins are added at the end of the file. Use the Sort One File menu selection to place the coins in their proper sequence. DELETE COIN RECORDS (use Edit One File) The Edit One File selection is used to tag a record that you wish to delete from the file. When in the paging mode, press C to enter the change mode. Move the arrows to the record that you wish to delete and press enter. When the program is asking for the date, type a single space and press enter. You do not have to make any changes to the remaining fields, so just press enter for the variety, grade, quantity, cost and value fields. The record will remain in the file until the next time the file is sorted. The file sort will remove all records which have a blank date. CHECKLIST (C) This selection will print a coin file in the familiar checklist format, totaling the number of coins in each grade. The program will print the total number of coins in each date/variety combination on one line, even if they are entered on more than one line in the file. Make sure that the file has been sorted since the last changes or additions to the file. As with the List Missing Coins function, entering a grade will cause the program to list only those coins below the specified grade. Enter 01 to list only the missing coins. Enter 71 to list the entire file. PRINT FILE LIST (F) Select F from the Main Menu. The screen will clear, and a selection box will be displayed. Press enter to list the files to the screen, or use the tab keys or mouse to select the printer. SORT ONE FILE (S) Select S from the Main Menu. You will be asked to select a denomination and file. After you have selected the file to be sorted, you will be given a choice of three types of sort. The first (1) SORT BY DATE / VARIETY is the standard sort for a coin set. (2) SORT BY VARIETY / DATE was included to sort the Commemorative Half Dollars by Variety. (3) SORT TYPE SET should be used only to sort the Type Set file. All of the sort options will work with any file, however the results may not be useful. When the sort process begins, the screen will clear, and a countdown will be displayed to show you the progress of the sort. If any coins in the file had been tagged for delete, you will see the message BLANK RECORDS FOUND. This means that the tagged records have been deleted. When the sort is complete, you will be returned to the menu. MASTER FILE SORT (M) Select M from the Main Menu. The program will begin sorting the Master File, displaying a countdown to show the progress of the sort. When the sort is complete, you will be returned to the menu. EDIT FILE DESCRIPTION (E) This function has been inc;uded in this program so that you may change the nomenclature I have used for naming the file denominations and series. Making changes to any of the other fields can be quite disastrous, and may cause the loss of some of your data. The fields which generally should not be changed are NUMBER OF RECORDS, and FILENAME. You can change DENOMINATION, VARIETY, and DATE with no danger of adverse affects. Changing VALUE will not cause any data to be lost but may cause coin files to be displayed in the wrong groupings. An example would be changing the VALUE of Franklin Half Dollars from 50 to 1. This would cause the Franklin Half Dollar file to be displayed on the file selection screen with cents. Of course, the file is still accessible, but would be hard to find since it would not be displayed on the normal Half Dollar file selection screen. Select E from the File Management menu. You must now select the denomination and the file to be changed. After a file is selected, the current file description will appear at the top of the screen. You will be asked if you wish to continue. At this prompt, you must type YES and press enter. Any other response will return you to the menu. If you answer YES, you will then be asked for an entry for each field. If you do not wish to change the data in the field, press enter. For the fields you wish to change, type the entire field entry and press enter. After all fields have been entered you will be asked to verify the entry. Type Y to accept the entry, or anything else to ignore the changes and return to the menu. At anytime during this process, enter a ? as the first and only character in a field to cancel the change process and return to the menu. While it is unlikely that you will lose any data by changing the file descriptions, the files may be hard to find, and could cause a great deal of confusion in trying to reconstruct the data. Just be careful in making changes to this file, and keep your back-ups up to date. DELETE ONE FILE (O) This selection will delete an entire coin file, and will remove the file descriptionfrom the Master Coin File. While it may be possible to recover a deleted file, extreme care should be exercised in the use of this function. If you think that you may need this file at some future time, you should use the Archive / Recall selection. Select O from the main menu. You will be asked to select a denomination and a file. Once a file has been selected, the existing Master File description for that file will be displayed at the top of the screen. In addition, if data has been entered in the value column of the file, the total value of the file will be displayed, and you will be asked to verify the deletion. Type Y and press enter to delete the file, type N and press enter (or just press enter) to cancel the delete process. If you should delete a file by mistake, it is possible to restore the file using an un-delete utility program. See the manual of your un-delete utility for the procedure to be used. You will need to be sure that the COINMSTR file contains a record describing the un-deleted file. CREATE A NEW FILE (N) This selection will allow you to add new files as new coins are issued, to add your own collection files, or to include some foreign coins. This selection includes several options that you can use to create new files, or copy data from existing files. The below session is set up in three parts to familiarize you with the operation of all of the options, and to show the versatility that this selection adds to the program. If you wish to add foriegn coin files, and do not want the denominations to conflict with existing US coins, you may elect to create the foriegn coin files on a seperate floppy, or keep them in a seperate directory. You will also need a copy of the program in the seperate directory. Part 1. In the first part of this session, we will create a new file without copying any records from other files. Select N from the menu, and when asked if you want to copy records from another file, answer N and press enter. The screen will clear, and you will be prompted to enter descriptive data for the new file. Enter the following data for this file: DENOMINATION DIMES VARIETY CLAD ROOSEVELT 1965 - DATE FACE VALUE 10 DATE 1965 You will be asked to verify the creation of this file. Answer Y and press enter. You will be back at the menu. Select E, and enter 10 for the face value of the file to be displayed. The file you just created will be at the bottom of the files listed on the selection screen. Enter tha number which appears to the left of the denomination and press enter. The file data for the new file will be displayed. Note that there is one record in the file for the date that was entered in the creation process. The data for quantity, cost and value are zero. Refer back to the section on deleting a file, and delete this new file. Part 2. In this part of the demo, we will create a file to record bulk quantities of Mercury Dimes. The new file will be a copy of the existing Mercury Dime file, but we will not copy the Quantity, Grade, Cost and Value data into the new file. From the menu, select N to create a new file. When asked if you wish to copy records from another file, answer Y and press enter. When asked if you wish to copy the entire file, answer Y and press enter. When asked if you wish to copy Grade, Quantity, Cost and Value data to the new file, answer N and press enter. You will now be asked to select the file from which the records are to be copied. Select the existing Mercury Dime file. After you have selected the file to be copied, you will be prompted to enter descriptive data for the new file. Enter the following data: DENOMINATION DIMES VARIETY BULK MERCURY 1916 - 1945 FACE VALUE 10 DATE 1916 You will be asked to verify the creation of the new file. Answer Y and press enter. The new file will be created, and the records will scroll by on the screen as they are being copied into the new file. When this is complete, you will be back at the menu. Select E, and view the new file. Note that all quantity, cost and value fields are 0, and all grades are blank. Refer back to the section on deleting a file, and delete this new file. Part 3. In this part of the demo, we will split the existing Roosevelt Dime file into two seperate files. The first file will contain the silver coins (1945 - 1964), and the second file will contain the clad coins (1965 - date). Before selecting N to create the new file, we must determine where to split the existing file. Select E, and bring up the Roosevelt Dime file. Page through the file until 1964D is displayed on the screen. Note that this coin is record #48 in the series. Enter ? to return to the menu, and select N to create a new file. When asked if you wish to copy records from an existing file, answer Y and press enter. When asked if you wish to copy the entire file, answer N and press enter. You will now be asked for the first record to be copied. We are creating a file for 1945 - 1964, so we want to copy records #1 thru #48. Answer 1 and press enter. The next question will ask for the last record to be copied. Answer 48 and press enter. You will now be asked if you wish to copy Quantity, Cost and Value data into the new file. Answer Y and press enter. The screen will clear, and you will be prompted to enter the data for the new file. Enter the following: DENOMINATION DIMES VARIETY SILVER ROOSEVELT 1945 - 1964 FACE VALUE 10 YEAR 1945 You will be asked to verify the creation of the file. The file will be created, and you will be returned to the menu. Now, on your own, create the file for 1965 - date. After completion of the above, you would normally either delete or archive the old file, however for this demo delete the two new files before continuing. MERGE TWO FILES (T) The file merge selection will combine two existing files into one file. The original files will not be deleted and will remain active. You may leave the files active in the KEYCOIN directory, or you may Archive them for future use. For this demonstration, we will combine Lincoln Cent files for wheat cents and memorial cents into a single file. From the Main Menu select (T). You will now see the familiar screen for selecting the denomination. Note the screen heading, "SELECT FIRST FILE TO BE MERGED". The first file should be the file with the earlier dates. In this case, the first file is Wheat Cents, so we enter 1 on this screen, and the file number for wheat cents on the next screen. After entering these selections, you will be asked to select the second file to be merged. Again, enter 1 on the first screen, and select the file number for Memorial cents on the second screen. You will now be asked to supply a variety for the new file. Enter LINCOLN CENTS 1909 - DATE. The screen will clear, and you will be shown the file definitions for the two files you have selected, and will be asked if you wish to merge the files. Answer Y for yes (anything else will return you to the menu). The program will then determine a name for the new file, and ask if you wish to create this new file. Answer Y for yes. The program will then create the new file, and copy the records from each of the selected files into the new file. After completion, the following information will be displayed; A NEW FILE HAS BEEN CREATED WITH THE FOLLOWING DATA NUMBER OF RECORDS 238 DENOMINATION SMALL CENT VARIETY LINCOLN CENTS 1909 - DATE VALUE 1 FIRST YEAR 1909 FILE NAME 000001xx PRESS ENTER TO RETURN TO THE MENU You may now use the Edit File Definition selection to change the above information, being careful not to change any critical data. (Number of Records, Value) You may now use the File Merge selection to merge this file with another. Remember that each time you merge two files, a new file is created. If you were to merge Indian Cents with this new file, the program will create a new file, and will leave the existing file intact and unchanged. If you happen to merge two files in the wrong sequence (later dates first), use the Sort One File selection to put the records in proper order. When you are familiar with the operation of all program functions, begin entering your own collection inventory. Good luck, and let me hear from you if you have any suggestions, of if you discover any bugs in the program. One of the problems with a program like this is that you no sooner finish with one improvement when you get an idea for another one. I will be constantly updating this program and adding new functions, so be sure to register to keep up with all of the improvements. This completes the sample session. Make sure that you are familiar with how these functions operate, and how the files are affected. There are many useful and helpful reports that you can get from the functions listed above. The more familiar you become with the program, the easier it will be to add, change and delete data. TYPE SET ENTRIES A special format has been used for entering the coin data for the type set included with this program. The format was developed to allow for a sort of the Type Set by denomination. This special format uses the first part of the variety description to indicate the denomination expressed as a decimal with two characters to the left of the decimal point. All leading zeroes must be entered. The entry for 1 cent would be 00.01, the entry for $1 would be 01.00, etc... The sort program for the Type Set will look at the first five characters of the variety field, and then will look at the Date field to determine the proper sort sequence. Only the first five positions of the variety field are critical to the sort. The remaining characters can be used as necessary to describe the variety. THE FOLLOWING FILES ARE INCLUDED WITH THE PROGRAM COINS FILE DENOMINATION VARIETY YEAR LISTED NAME HALF CENT LIBERTY CAP 1793 12 0000005A HALF CENT DRAPED BUST 1800 16 0000005B HALF CENT CLASSIC HEAD 1809 14 0000005C HALF CENT CORONET 1840 29 0000005D LARGE CENT FLOWING HAIR - WREATH 1793 3 000001A1 LARGE CENT LIBERTY CAP 1793 7 000001A2 LARGE CENT DRAPED BUST 1796 32 000001A3 LARGE CENT CLASSIC HEAD 1808 9 000001A4 LARGE CENT CORONET 1816 28 000001A5 LARGE CENT CORONET - BRAIDED HAIR 1835 31 000001A6 SMALL CENT FLYING EAGLE 1856 5 000001A7 SMALL CENT INDIAN HEAD 1859 54 000001A8 SMALL CENT LINCLON - WHEAT 1909 143 000001A9 SMALL CENT LINCLON - MEMORIAL 1959 95 000001B1 SMALL CENT - BULK LINCLON 1909 130 000001B2 TWO CENT SHIELD 1864 12 000002A1 THREE CENT SILVER 1851 26 000003A1 THREE CENT NICKEL 1865 25 000003A2 HALF DIME FLOWING HAIR 1793 8 000005A1 HALF DIME DRAPED BUST 1796 6 000005A2 HALF DIME CAPPED BUST 1829 37 000005A3 HALF DIME LIBERTY SEATED 1837 84 000005A4 FIVE CENT SHIELD 1866 21 000005A5 FIVE CENT LIBERTY HEAD 1883 34 000005A6 FIVE CENT INDIAN HEAD / BUFFALO 1913 69 000005A7 FIVE CENT JEFFERSON 1938 144 000005A8 DIME DRAPED BUST 1796 13 000010A1 DIME CAPPED BUST - LARGE SIZE 1809 14 000010A2 DIME CAPPED BUST - REDUCED SIZE 1828 14 000010A3 DIME LIBERTY SEATED 1837 118 000010A4 DIME LIBERTY HEAD / BARBER 1892 77 000010A5 DIME WINGED LIBERTY / MERCURY 1916 80 000010A6 DIME ROOSEVELT 1946 125 000010A7 TWENTY CENT LIBERTY SEATED 1875 7 000020A1 QUARTER DOLLAR DRAPED BUST 1796 6 000025A1 QUARTER DOLLAR CAPPED BUST - LARGE SIZE 1815 16 000025A2 QUARTER DOLLAR CAPPED BUST - REDUCED SIZE 1831 8 000025A3 QUARTER DOLLAR LIBERTY SEATED 1838 112 000025A4 QUARTER DOLLAR LIBERTY HEAD / BARBER 1892 74 000025A5 QUARTER DOLLAR STANDING LIBERTY 1916 38 000025A6 QUARTER DOLLAR WASHINGTON 1932 158 000025A7 QUARTER DOLLAR COMMEMORATIVE 1893 1 000025A8 HALF DOLLAR FLOWING HAIR 1794 4 000050A1 HALF DOLLAR DRAPED BUST 1796 12 000050A2 HALF DOLLAR CAPPED BUST 1807 53 000050A3 HALF DOLLAR LIBERTY SEATED 1839 116 000050A4 HALF DOLLAR LIBERTY HEAD / BARBER 1892 73 000050A5 HALF DOLLAR WALKING LIBERTY 1916 65 000050A6 HALF DOLLAR FRANKLIN 1948 35 000050A7 HALF DOLLAR KENNEDY 1964 79 000050A8 HALF DOLLAR COMMEMORATIVE 1892 146 000050A9 FIRST COINS FILE DENOMINATION VARIETY YEAR LISTED NAME MINT SET MINT SET 1947 47 000099A1 PROOF SETS PROOF SETS 1936 60 000099A2 TYPE SET US COINS 1793 82 000099A3 DOLLAR FLOWING HAIR 1794 2 000100A1 DOLLAR DRAPED BUST 1795 11 000100A2 DOLLAR LIBERTY SEATED 1836 44 000100A3 DOLLAR TRADE 1873 24 000100A4 DOLLAR LIBERTY HEAD / MORGAN 1878 98 000100A5 DOLLAR PEACE 1921 24 000100A6 DOLLAR EISENHOWER 1971 27 000100A7 DOLLAR ANTHONY 1979 12 000100A8 DOLLAR SILVER EAGLE 1986 9 000100A9 GOLD DOLLAR LIBERTY HEAD 1849 25 000100B1 GOLD DOLLAR INDIAN HEAD 1854 53 000100B2 DOLLAR COMMEMORATIVE 1900 17 000100B3 QUARTER EAGLE LIBERTY CAPPED 1796 11 000250A1 QUARTER EAGLE ROUND CAP 1808 12 000250A2 QUARTER EAGLE CLASSIC HEAD 1834 10 000250A3 QUARTER EAGLE CORONET 1840 137 000250A4 QUARTER EAGLE INDIAN HEAD 1908 15 000250A5 QUARTER EAGLE COMMEMORATIVE 1926 1 000250A6 THREE DOLLAR GOLD INDIAN HEAD 1854 43 000300A1 FOUR DOLLAR GOLD LIBERTY HEAD 1879 4 000400A1 HALF EAGLE CAPPED BUST 1795 17 000500A1 HALF EAGLE DRAPED BUST 1807 7 000500A2 HALF EAGLE LIBERTY CAPPED 1813 25 000500A3 HALF EAGLE CLASSIC HEAD 1834 8 000500A4 HALF EAGLE CORONET 1839 208 000500A5 HALF EAGLE INDIAN HEAD 1908 24 000500A6 FIVE DOLLAR GOLD EAGLE 1986 8 000500A7 FIVE DOLLAR COMMEMORATIVE 1900 8 000500A8 EAGLE LIBERTY CAPPED 1795 11 001000A1 EAGLE CORONET 1838 180 001000A2 EAGLE INDIAN HEAD 1907 27 001000A3 TEN DOLLAR GOLD EAGLE 1986 5 001000A4 TEN DOLLAR COMMEMORATIVE 1984 5 001000A5 DOUBLE EAGLE LIBERTY HEAD 1850 146 002000A1 DOUBLE EAGLE ST GAUDENS 1907 54 002000A2 TWENTY-FIVE DOLLAR GOLD EAGLE 1986 9 002500A1 FIFTY DOLLAR GOLD EAGLE 1986 10 005000A1